<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed'); ?>

INFO  - 2011-05-20 08:57:21 --> [ 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-20 08:57:21 --> [ 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-20 08:57:21 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-20 08:57:26 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE ( order_status = '1' OR order_status = '2')
ORDER BY `po_id`<br/>
INFO  - 2011-05-20 08:57:28 --> [note 127.0.0.1] select pf.coil_group_code 	,pf.thickness 	,pf.width 	,pf.product_dtl_id 	,pf.slit_date 	,pf.unit 	,pf.weight 	,( select program_code from prd_product_produce where coil_group_code = pf.coil_group_code and product_dtl_id = pf.product_dtl_id ) as program_code 	,( select ppi.program_code_ext 		from prd_program_information ppi, prd_product_produce pp 		where pp.coil_group_code = pf.coil_group_code 			and pp.product_dtl_id = pf.product_dtl_id 			and ppi.product_dtl_id = pf.product_dtl_id 			and ppi.program_code = pp.program_code 		limit 1 ) as program_code_ext from vr_prd_film pf where pf.populate_flag = 'N' order by slit_date desc<br/>
INFO  - 2011-05-20 08:57:29 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
ORDER BY `product_display_id` asc<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM36_03'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114410265
AND `coil_lot_no` = '7'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114490165
AND `coil_lot_no` = '8'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114280423
AND `coil_lot_no` = '9'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114250593
AND `coil_lot_no` = '10'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114250575
AND `coil_lot_no` = '11'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114280433
AND `coil_lot_no` = '12'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114390163
AND `coil_lot_no` = '13'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_coil_status`)
ORDER BY CAST(coil_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 08:57:33 --> [note 127.0.0.1] select pf.coil_group_code 	,pf.thickness 	,pf.width 	,pf.product_dtl_id 	,pf.slit_date 	,pf.unit 	,pf.weight 	,( select program_code from prd_product_produce where coil_group_code = pf.coil_group_code and product_dtl_id = pf.product_dtl_id ) as program_code 	,( select ppi.program_code_ext 		from prd_program_information ppi, prd_product_produce pp 		where pp.coil_group_code = pf.coil_group_code 			and pp.product_dtl_id = pf.product_dtl_id 			and ppi.product_dtl_id = pf.product_dtl_id 			and ppi.program_code = pp.program_code 		limit 1 ) as program_code_ext from vr_prd_film pf where pf.populate_flag = 'N' order by slit_date desc<br/>
INFO  - 2011-05-20 08:57:33 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
ORDER BY `product_display_id` asc<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM36_03'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114410265
AND `coil_lot_no` = '7'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114490165
AND `coil_lot_no` = '8'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114280423
AND `coil_lot_no` = '9'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114250593
AND `coil_lot_no` = '10'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114250575
AND `coil_lot_no` = '11'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114280433
AND `coil_lot_no` = '12'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_coil`)
WHERE `coil_id` = 1114390163
AND `coil_lot_no` = '13'
AND `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:35 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_coil_status`)
ORDER BY CAST(coil_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 08:57:39 --> [note 127.0.0.1] select pf.coil_group_code 	,pf.thickness 	,pf.width 	,pf.product_dtl_id 	,pf.slit_date 	,pf.unit 	,pf.weight 	,( select program_code from prd_product_produce where coil_group_code = pf.coil_group_code and product_dtl_id = pf.product_dtl_id ) as program_code 	,( select ppi.program_code_ext 		from prd_program_information ppi, prd_product_produce pp 		where pp.coil_group_code = pf.coil_group_code 			and pp.product_dtl_id = pf.product_dtl_id 			and ppi.product_dtl_id = pf.product_dtl_id 			and ppi.program_code = pp.program_code 		limit 1 ) as program_code_ext from vr_prd_film pf where pf.populate_flag = 'N' order by slit_date desc<br/>
INFO  - 2011-05-20 08:57:39 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
ORDER BY `product_display_id` asc<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `coil_group_code`
FROM (`prd_product_produce`)
WHERE `program_code` = 'PC000401'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL87_01'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_01'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_01'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL87_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_02'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL87_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL87'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_03'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL87_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_04'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_04'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_04'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_07'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_07'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_07'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL90_01'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL90'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL90'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL90'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL90'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL90_01'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL90_01'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_08'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_08'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:43 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_08'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_10'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_10'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_10'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_11'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_11'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_11'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_12'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_12'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_12'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_13'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_13'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_13'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_14'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_14'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_14'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_18'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_18'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_18'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OL65_19'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OL65'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_19'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OL65_19'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM27_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_02'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM27_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_03'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM27_05'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM27'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_05'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM27_05'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM36_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM36_02'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM36_02'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`vr_prd_film`)
WHERE `coil_group_code` = 'OM36_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`ord_order_information`)
WHERE `po_id` = 'OM36'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `vat_code`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM36_03'
AND `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `expense`
FROM (`prd_product_produce`)
WHERE `coil_group_code` = 'OM36_03'
AND `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT DISTINCT `machine_by`
FROM (`prd_product_produce`)
WHERE `program_code` = 'PC000401'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000401'
AND `product_dtl_id` = '0004'
ORDER BY `processing_date` asc<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `program_status`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000401'
AND `product_dtl_id` = '0004'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `program_code_ext`
FROM (`prd_program_information`)
WHERE `program_code` = 'PC000401'
AND `product_dtl_id` = '0004'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT fr_prd_get_avg_weight('PC000401') as avg_weight<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT fr_prd_get_perct_grade_b('PC000401') as grade_b<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT fr_prd_get_avg_per_unit('PC000401', '0004') as cost<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT fr_prd_get_avg_cost_per_unit('PC000401', '0004') as cost_and_wage<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT `est_weight`
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0004'
LIMIT 1<br/>
INFO  - 2011-05-20 08:57:44 --> [note 127.0.0.1] SELECT *
FROM (`prd_product_detail`)
WHERE `product_dtl_id` = '0004'<br/>
INFO  - 2011-05-20 09:05:05 --> [note 127.0.0.1] SELECT *
FROM (`usr_user_information`)
WHERE `username` = 'note'
AND `password` = 'note'<br/>
INFO  - 2011-05-20 09:05:05 --> [note 127.0.0.1] SELECT `permission`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-20 09:05:05 --> [note 127.0.0.1] SELECT `user_type`
FROM (`usr_user_information`)
WHERE `username` = 'note'<br/>
INFO  - 2011-05-20 09:05:11 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:05:11 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:07:05 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:07:05 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:07:16 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:07:16 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:07:29 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:07:29 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:07:41 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:07:41 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:07:55 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:07:55 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:08:08 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:08:08 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:08:15 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:08:15 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:08:15 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:08:15 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:08:24 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:08:24 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:08:24 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:08:24 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:14:36 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:14:36 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:14:45 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:14:45 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:14:45 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-20', '720', 'Y', 'TEST', 'note', '2011-05-20 09:14:45')<br/>
INFO  - 2011-05-20 09:14:45 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-20', '1400', 'note', '2011-05-20 09:14:45')<br/>
INFO  - 2011-05-20 09:14:46 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:14:46 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:16:29 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:16:29 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:18:18 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:18:18 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:18:21 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:18:21 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:18:23 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:18:23 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:18:49 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:18:49 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:18:56 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:18:56 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:19:16 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:19:16 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:24:20 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:24:20 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:24:22 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:24:22 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:24:23 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:24:23 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:24:25 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:24:25 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:24:50 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 09:24:50 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 09:35:25 --> [note 127.0.0.1] SELECT *
FROM (`vr_ord_order`)
WHERE `order_status` = '1'
ORDER BY `order_received_date` desc, `po_id` asc<br/>
INFO  - 2011-05-20 09:35:25 --> [note 127.0.0.1] SELECT `supplier_id`, `supplier_name`
FROM (`crm_supplier_information`)<br/>
INFO  - 2011-05-20 09:35:25 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_order_status`)
ORDER BY CAST(order_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:07:07 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:07:48 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:08:10 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:08:49 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:27:53 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) FROM vr_mc_machine_work_hour WHERE work_date BETWEEN  AND <br/>
INFO  - 2011-05-20 10:28:14 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) FROM vr_mc_machine_work_hour WHERE work_date BETWEEN 2011-05-09 AND 2011-05-20<br/>
INFO  - 2011-05-20 10:28:30 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) FROM vr_mc_machine_work_hour WHERE work_date BETWEEN 2011-05-09 AND 2011-05-20<br/>
INFO  - 2011-05-20 10:29:48 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:30:26 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:31:08 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:31:31 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(duration) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:34:33 --> [note 127.0.0.1] SELECT mc_id, machine_name, SUM(IFNULL(duration, 0)) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:36:27 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration, 0)) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:36:39 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0)) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:36:44 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_work_hour WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:38:02 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0), work_date FROM `vr_mc_machine_work_hour` GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:38:10 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration, work_date FROM `vr_mc_machine_work_hour` GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:42:22 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration, work_date FROM `vr_mc_machine_work_hour` GROUP BY mc_id HAVING work_date BETWEEN 2011-05-09 AND 2011-05-20<br/>
INFO  - 2011-05-20 10:42:30 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration, work_date FROM `vr_mc_machine_work_hour` GROUP BY mc_id HAVING work_date BETWEEN 2011-05-09 AND 2011-05-20<br/>
INFO  - 2011-05-20 10:43:27 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN 2011-05-09 AND 2011-05-20 GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:43:57 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:44:55 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration, IFNULL(work_date, '2011-05-20') FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:46:48 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:46:54 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:47:22 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:47:22 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:47:29 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:47:29 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:47:32 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:47:32 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:47:39 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:47:39 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:47:39 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-15', '480', 'N', '', 'note', '2011-05-20 10:47:39')<br/>
INFO  - 2011-05-20 10:47:39 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-15', '100', 'note', '2011-05-20 10:47:39')<br/>
INFO  - 2011-05-20 10:47:40 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:47:40 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:47:49 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:47:54 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:48:07 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:48:07 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:48:11 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:48:11 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-16', '720', 'Y', '', 'note', '2011-05-20 10:48:15')<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-16', '100', 'note', '2011-05-20 10:48:15')<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('2', '2011-05-16', '480', 'N', '', 'note', '2011-05-20 10:48:15')<br/>
INFO  - 2011-05-20 10:48:15 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 1, '2011-05-16', '100', 'note', '2011-05-20 10:48:15')<br/>
INFO  - 2011-05-20 10:48:16 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:48:16 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 10:48:20 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:48:24 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 10:48:57 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:48:57 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:50:46 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:50:46 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:55:31 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:55:31 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:55:38 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:55:38 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:58:29 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:58:29 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:20 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:20 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:25 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:25 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:27 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:27 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:32 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:32 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:34 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:34 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 10:59:47 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 10:59:47 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 11:00:23 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:00:23 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 11:01:28 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:01:28 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 11:01:30 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:01:30 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 11:01:34 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:01:34 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:05:22 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:05:22 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-20', '720', 'Y', 'TEST', 'note', '2011-05-20 11:05:24')<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-20', '1400', 'note', '2011-05-20 11:05:24')<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('2', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:05:24')<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('3', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:05:24')<br/>
INFO  - 2011-05-20 11:05:24 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('4', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:05:24')<br/>
INFO  - 2011-05-20 11:05:25 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:05:25 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-20', '720', 'Y', 'TEST', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-20', '1400', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('2', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('3', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('4', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:17 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:17')<br/>
INFO  - 2011-05-20 11:06:18 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:06:18 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-20', '720', 'Y', 'TEST', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-20', '1400', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('2', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('3', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('4', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 1, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 2, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 3, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 4, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:56 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 5, '2011-05-20', '0', 'note', '2011-05-20 11:06:56')<br/>
INFO  - 2011-05-20 11:06:58 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:06:58 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:07:19 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 11:19:59 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:19:59 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 11:20:03 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 11:20:22 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 11:20:22 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 11:21:20 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 12:19:07 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 12:20:44 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 12:20:47 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-19' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 12:20:50 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 12:43:08 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:01:46 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:01:59 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:02:09 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:03:13 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:11:34 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:12:29 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:13:06 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:13:06 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:14:32 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:14:32 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:15:01 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:15:01 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:16:13 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:16:13 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:16:20 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:16:20 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:16:29 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:16:29 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:16:41 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:16:41 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:16:50 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:16:50 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:18:06 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:18:06 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:18:39 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:18:39 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:19:08 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:19:08 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:19:43 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:19:43 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:20:44 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:20:44 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:21:00 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:21:00 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:21:07 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:21:07 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:21:37 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:21:37 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:22:59 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:22:59 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:12 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-08' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:12 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:17 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-01' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:17 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:19 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-01' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:19 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:20 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-01' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:20 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:26 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:26 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:30 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-01' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:30 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:33 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:33 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:48 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:48 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:49 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:49 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:23:54 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:23:54 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:24:16 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:24:16 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:24:52 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:24:52 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:25:14 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:25:14 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:28 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:34 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:53 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:25:57 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-11' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:26:47 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:27:18 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:54:25 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-19' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:36 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 13:55:39 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:25 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:01:36 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:02:13 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-18' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:04:48 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-09' AND '2011-05-21' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-09' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-09' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-09' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-09' AND '2011-05-21' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:05:02 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:09:46 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 14:20:06 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:58:58 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 15:58:58 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 15:59:02 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:59:07 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 15:59:07 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 15:59:11 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:59:15 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 15:59:15 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 15:59:15 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:59:18 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '1'<br/>
INFO  - 2011-05-20 15:59:19 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 15:59:21 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '1'<br/>
INFO  - 2011-05-20 15:59:22 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:00:45 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '1'<br/>
INFO  - 2011-05-20 16:00:46 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:01:54 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '1'<br/>
INFO  - 2011-05-20 16:01:55 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:01:59 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '5'<br/>
INFO  - 2011-05-20 16:02:00 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:03 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '4'<br/>
INFO  - 2011-05-20 16:02:04 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:06 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '3'<br/>
INFO  - 2011-05-20 16:02:07 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:10 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '2'<br/>
INFO  - 2011-05-20 16:02:11 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:28 --> [note 127.0.0.1] DELETE FROM `mc_machine_config`
WHERE `machine_config_id` = '5'<br/>
INFO  - 2011-05-20 16:02:29 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:34 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:02:34 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('1', '2011-05-20', '720', 'Y', 'TEST', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 1, '2011-05-20', '100', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 2, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 3, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('1', 4, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('2', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 1, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 2, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 3, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('2', 4, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('3', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 1, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 2, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 3, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('3', 4, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_work_hour` (`mc_id`, `work_date`, `duration`, `ot`, `comment`, `record_change_by`, `record_change_date`) VALUES ('4', '2011-05-20', '480', 'N', '', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 1, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 2, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 3, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:38 --> [note 127.0.0.1] INSERT INTO `mc_machine_manage` (`mc_id`, `machine_config_id`, `manage_date`, `duration`, `record_change_by`, `record_change_date`) VALUES ('4', 4, '2011-05-20', '0', 'note', '2011-05-20 16:02:38')<br/>
INFO  - 2011-05-20 16:02:39 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:02:39 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:45 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:02:45 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 16:02:47 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:49 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '1'<br/>
INFO  - 2011-05-20 16:02:49 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:02:52 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `machine_config_id` = '4'<br/>
INFO  - 2011-05-20 16:02:53 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:04:39 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:04:39 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:04:42 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT mc_id, machine_name, IFNULL(SUM(duration), 0) as duration FROM `vr_mc_machine_work_hour` WHERE work_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY mc_id<br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 1 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 2 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 3 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT machine_config_id, machine_config_name, IFNULL(SUM(duration), 0) as duration FROM vr_mc_machine_config_time WHERE mc_id = 4 AND manage_date BETWEEN '2011-05-20' AND '2011-05-20' GROUP BY machine_config_id <br/>
INFO  - 2011-05-20 16:19:56 --> [note 127.0.0.1] SELECT * FROM mc_machine_config ORDER BY machine_config_id ASC<br/>
INFO  - 2011-05-20 16:20:03 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:20:03 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 16:20:06 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `mc_id` = '1'<br/>
INFO  - 2011-05-20 16:20:07 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:20:07 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
INFO  - 2011-05-20 16:20:10 --> [note 127.0.0.1] SELECT COUNT(*) AS `numrows`
FROM (`mc_machine_manage`)
WHERE `mc_id` = '4'<br/>
INFO  - 2011-05-20 16:20:11 --> [note 127.0.0.1] SELECT * FROM vr_mc_machine_info ORDER BY mc_id<br/>
INFO  - 2011-05-20 16:20:11 --> [note 127.0.0.1] SELECT *
FROM (`vr_gen_machine_status`)
ORDER BY CAST(machine_status_code AS UNSIGNED)<br/>
